SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{530553c50ea08dc90fb60a79cc6a806c466991018da97e654383d1301e8d2da3}Haan{530553c50ea08dc90fb60a79cc6a806c466991018da97e654383d1301e8d2da3}' OR prCity = 'Haan' OR prZip = 'Haan' OR prStreet LIKE '{530553c50ea08dc90fb60a79cc6a806c466991018da97e654383d1301e8d2da3}Haan{530553c50ea08dc90fb60a79cc6a806c466991018da97e654383d1301e8d2da3}' OR prCountry = 'Haan') AND (prLocation LIKE '{530553c50ea08dc90fb60a79cc6a806c466991018da97e654383d1301e8d2da3}Germany{530553c50ea08dc90fb60a79cc6a806c466991018da97e654383d1301e8d2da3}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{530553c50ea08dc90fb60a79cc6a806c466991018da97e654383d1301e8d2da3}Germany{530553c50ea08dc90fb60a79cc6a806c466991018da97e654383d1301e8d2da3}' OR prCountry = 'Germany')